package com.banhujiu.spider.region.conf

/**
 * @author banhujiu
 * @date 2017/11/19 0019 22:25
 */
val queueSize = Integer.MAX_VALUE
val siteUrl = "http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2016/index.html"
val charsetName = "GBK"
val codeSize = 12
val sqlInsertSize = 500
val areaTableName = "sys_area"


val filePath = "D://"
val fileName = "area.sql"
val fileSuffix = ".sql"
val initString =
        "DROP TABLE IF EXISTS `" + areaTableName + "`;\n" +
                "CREATE TABLE `" + areaTableName + "` (\n" +
                "  `code`     BIGINT(20) COMMENT '统计用区划代码',\n" +
                "  `name`     VARCHAR(64) COMMENT '名称',\n" +
                "  `level`    TINYINT(4)  COMMENT '地址等级',\n" +
                "  `p_code` VARCHAR(64) COMMENT '上级CODE'\n" +
                ") ENGINE=InnoDB DEFAULT CHARSET = utf8;\n" +
                "ALTER TABLE `" + areaTableName + "` ADD UNIQUE (code);\n"
